Exploratory Water Analysis Report¶

Report created by A.J. Brown\ 27 Jan 2022\ Using Python 3.9.6\ Jupyter Lab 3.2.1\ Script Version 0.7

Introduction¶

The following script is a data report containing water quality data from samples taken in 2021 in the Yampa River Valley by the Colorado State University (CSU) Agriculture Water Quality Program (AWQP). For more information, please contact Erik Wardle at Erik.Wardle@colostate.edu or visit the CSU AWQP Website at https://waterquality.colostate.edu.

Table of contents¶

  1. Interactive Graphics
    1. Boxplot
    2. Scatterplot
    3. Correlation Matrix of All Numerical Values
  2. Table of Raw Data

Sample ID Legend¶

All samples were identified using abbreviations corresponding to locations as noted in the legend below:

Sample ID Location
SCI Stagecoach Inlet
SCA Stagecoach Resevoir
SCB Stagecoach Spillway
DS Ranch
CM Catamount

Interactive Graphics ¶

Boxplot ¶

Use the below boxplot to graph various water analytes stratified by sample type (i.e., Inflow, Outflow, etc.). Analytes can be selected by using the dropdown menu on the top left of the graph. Hover over points with your mouse for additional information.

Scatterplot ¶

Use the below Scatter plot to graph various water analytes against each other to see potential relationships. Analytes can be selected by using the dropdown menus near top left of the graph. Hover over points with your mouse for additional information.

Scatter Matrix of All Numerical Values ¶

Use the below scatter matrix to look at potential relationships between numerical variables.
Points are stratified by sample type (i.e., Inflow, Outflow, etc.). Hover over points with your mouse for additional information.

Table of Raw Data ¶

Location Date Irr./Storm Event Sample Type Replication ID Sample ID Orthophosphate (mg/L) NO3 (mg/L) TKN (mg/L) Total Phosphorus (mg/L) selenium(mg/L) TSS (g/L) Year hex
0 Yampa Valley 6/14/2021 Grab 1 SCI 1 SB-SCI-01-GB NaN NaN 1.50 0.170 NaN 80.000000 2021 #1f77b4
1 Yampa Valley 6/14/2021 Grab 1 SCI 2 SB-SCI-01-GB-D NaN NaN 1.10 0.190 NaN 103.333333 2021 #1f77b4
2 Yampa Valley 6/14/2021 Grab 1 SCA 1 SB-SCA-01-GB NaN NaN NaN 0.077 NaN 10.000000 2021 #ff7f0e
3 Yampa Valley 6/14/2021 Grab 1 SCA 2 SB-SCA-01-GB-D NaN NaN NaN 0.066 NaN 16.666667 2021 #ff7f0e
4 Yampa Valley 6/14/2021 Grab 1 SCB 1 SB-SCB-01-GB NaN NaN NaN NaN NaN 10.000000 2021 #2ca02c
5 Yampa Valley 6/14/2021 Grab 1 SCB 2 SB-SCB-01-GB-D NaN NaN NaN 0.061 NaN 10.000000 2021 #2ca02c
6 Yampa Valley 6/14/2021 Grab 1 DS 1 SB-DS-01-GB NaN NaN NaN NaN NaN 10.000000 2021 #d62728
7 Yampa Valley 6/14/2021 Grab 1 DS 2 SB-DS-01-GB-D NaN NaN NaN NaN NaN 13.333333 2021 #d62728
8 Yampa Valley 7/28/2021 Grab 2 SCI 1 SB-SCI-02-GB NaN NaN 0.93 0.084 NaN 40.000000 2021 #1f77b4
9 Yampa Valley 7/28/2021 Grab 2 SCI 2 SB-SCI-02-GB-D NaN NaN 1.90 0.092 NaN 26.666667 2021 #1f77b4
10 Yampa Valley 7/28/2021 Grab 2 SCA 1 SB-SCA-02-GB NaN NaN NaN 0.079 NaN 13.333333 2021 #ff7f0e
11 Yampa Valley 7/28/2021 Grab 2 SCA 2 SB-SCA-02-GB-D NaN NaN NaN 0.066 NaN 10.000000 2021 #ff7f0e
12 Yampa Valley 7/28/2021 Grab 2 SCB 1 SB-SCB-02-GB NaN NaN NaN 0.079 NaN 156.666667 2021 #2ca02c
13 Yampa Valley 7/28/2021 Grab 2 SCB 2 SB-SCB-02-GB-D NaN NaN NaN 0.071 NaN 13.333333 2021 #2ca02c
14 Yampa Valley 7/28/2021 Grab 2 DS 1 SB-DS-02-GB NaN NaN NaN 0.071 NaN 13.333333 2021 #d62728
15 Yampa Valley 7/28/2021 Grab 2 DS 2 SB-DS-02-GB-D NaN NaN NaN 0.074 NaN 6.666667 2021 #d62728
16 Yampa Valley 7/28/2021 Grab 2 CM 1 SB-CM-02-GB NaN NaN NaN 0.079 NaN 16.666667 2021 #9467bd
17 Yampa Valley 7/28/2021 Grab 2 CM 2 SB-CM-02-GB-D NaN NaN NaN 0.053 NaN 6.666667 2021 #9467bd